package com.ctshk.rpc.system.mapper.app;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ctshk.rpc.system.dto.app.ScenicProductTypeDTO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface MainDataScenicProductTypeMapper extends BaseMapper<ScenicProductTypeDTO> {
    @Select("SELECT DISTINCT " +
            "t_scenic_product_type_icon.id AS id,  " +
            "t_scenic_product_type_icon.`name` AS `name`,  " +
            "t_scenic_product_type_icon.photos AS photos,  " +
            "t_scenic_product_type_icon.`status` AS `status` " +
            "FROM " +
            "t_scenic_product_type_icon " +
            "WHERE status = 0")
    List<ScenicProductTypeDTO> selectScenicProductTypeList();
}
